select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'MA' order by rank asc limit 0,100 Surnames > M > MA > %22

Surnames > M > MA > %22

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
MA MB MC ME MG MH MI MJ MK ML MN MO MP MR MU MW MY
MA MAA MAB MAC MAD MAE MAF MAG MAH MAI MAJ MAK MAL MAM MAN MAO MAP MAQ MAR MAS MAT MAU MAV MAW MAX MAY MAZ

Full Surname List Starting with %22(Alphabetical)